﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using IHISCETeim.DAL;
using IHISCETeim.Model;
using IHISCETeim.Library;
using System.Data;

namespace IHISCETeim.BLL
{
    public class FXSJZYController
    {
        /// <summary>
        /// 三井信友逾期情况，删除
        /// 当导入前操作
        /// </summary>
        /// <returns></returns>
        public static string Clear()
        {
            return FXSJZYDAL.Clear();
        }

        /// <summary>
        /// 三井住友逾期情况-经销商
        /// 导入
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static int FXSJZYAgentImportFromExecl(FXSJZYAgentInfo obj)
        {
            return FXSJZYDAL.FXSJZYAgentImportFromExecl(obj);
        }
        /// <summary>
        /// 三井住友逾期情况-经销商
        /// 根据条件获取
        /// </summary>
        /// <param name="sqlwhere"></param>
        /// <returns></returns>
        public static DataTable FXSJZYAgentGetByWhere(string sqlwhere)
        {
            return FXSJZYDAL.FXSJZYAgentGetByWhere(sqlwhere);
        }


        /// <summary>
        /// 三井住友逾期情况-客户逾期明细
        /// 导入
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static int FXSJZYDetailImportFromExecl(FXSJZYDetailInfo obj)
        {
            return FXSJZYDAL.FXSJZYDetailImportFromExecl(obj);
        }

        public static DataTable FXSJZYDetailGetPagination(string WhereSql, int PageIndex, int PageSize, string Sort, ref int TotalCount)
        {
            return FXSJZYDAL.FXSJZYDetailGetPagination(WhereSql, PageIndex, PageSize, Sort, ref  TotalCount);
        }
        /// <summary>
        /// 获取最新的上传时间
        /// </summary>
        /// <returns></returns>
        public static string FXSJZYAgent_GetUpdateDate()
        {
            return FXSJZYDAL.FXSJZYAgent_GetUpdateDate();
        }
    }
}
